<?php
/*
	Copyright 2006, 2007, 2008, 2009, 2010 Bastiaan Grutters
    
    This file is part of Ages of Strife website.

    Ages of Strife website is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Ages of Strife website is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with Ages of Strife website.  If not, see <http://www.gnu.org/licenses/>.
 */
include( '../global/initialize.php' );

if( isset( $_GET[ 'type' ] ) ) {
	$type = formatInput( $_GET[ 'type' ] );
	//print( "$type" );
	if( $type == "unread" ) {
	    $query = "SELECT * FROM news WHERE ruler_id = " . $_SESSION[ 'ruler_id' ] . " AND seen = 0 ORDER BY turn DESC";
	    $result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
	}
	else {
	    $query = "SELECT * FROM news WHERE ruler_id = " . $_SESSION[ 'ruler_id' ] . " AND type = '" . $type . "' ORDER BY turn DESC";
	    $result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
	}
    $num = mysql_numrows( $result );
    $action = "";
    if( isset( $_POST[ 'unread' ] ) ) {
		$action = "unread";    	
    }
    else if( isset( $_POST[ 'read' ] ) ) {
		$action = "read";    	
    }
    else if( isset( $_POST[ 'delete' ] ) ) {
		$action = "delete";    	
    }
    
    $i = 0;
    while ( $i < $num ) {
    	if( isset( $_POST[ $i ] ) ) {
    		if( $action == "unread" ) {
				$query = "UPDATE news SET seen = 0 WHERE news_id = " . mysql_result( $result, $i, "news_id" );
				mysql_query( $query ) or die( "Query failed : " . mysql_error() );
    		}
    		else if( $action == "read" ) {
				$query = "UPDATE news SET seen = 1 WHERE news_id = " . mysql_result( $result, $i, "news_id" );
				mysql_query( $query ) or die( "Query failed : " . mysql_error() );
    		}
    		else if( $action == "delete" ) {
				$query = "DELETE FROM news WHERE news_id = " . mysql_result( $result, $i, "news_id" );
				mysql_query( $query ) or die( "Query failed : " . mysql_error() );
    		}
    	}
        $i ++;
    }
    if( $type == "unread" ) {
		header( "Location: news.php" );
    }
    else {
		header( "Location: news_list.php?type=$type" );
    }
}
else {
	header( "Location: news.php" );
}
?>
